from sqlalchemy import Column, CHAR, String, Integer, DateTime
from config.database import Base


class KhMonthlyAttendance(Base):
    """
    考勤月报表表
    """

    __tablename__ = 'kh_monthly_attendance'

    id = Column(Integer, primary_key=True, autoincrement=True, nullable=False, comment='序号')
    user_name = Column(String(50), nullable=False, comment='用户姓名')
    user_id = Column(String(20), nullable=False, comment='用户编号')
    kh_month = Column(String(20), nullable=False, comment='考勤月份')
    am_pm = Column(String(20), nullable=False, comment='考勤时段')
    kh_work = Column(String(20), nullable=False, comment='考勤类型')
    day1 = Column(String(20), nullable=True, comment='1日')
    day2 = Column(String(20), nullable=True, comment='2日')
    day3 = Column(String(20), nullable=True, comment='3日')
    day4 = Column(String(20), nullable=True, comment='4日')
    day5 = Column(String(20), nullable=True, comment='5日')
    day6 = Column(String(20), nullable=True, comment='6日')
    day7 = Column(String(20), nullable=True, comment='7日')
    day8 = Column(String(20), nullable=True, comment='8日')
    day9 = Column(String(20), nullable=True, comment='9日')
    day10 = Column(String(20), nullable=True, comment='10日')
    day11 = Column(String(20), nullable=True, comment='11日')
    day12 = Column(String(20), nullable=True, comment='12日')
    day13 = Column(String(20), nullable=True, comment='13日')
    day14 = Column(String(20), nullable=True, comment='14日')
    day15 = Column(String(20), nullable=True, comment='15日')
    day16 = Column(String(20), nullable=True, comment='16日')
    day17 = Column(String(20), nullable=True, comment='17日')
    day18 = Column(String(20), nullable=True, comment='18日')
    day19 = Column(String(20), nullable=True, comment='19日')
    day20 = Column(String(20), nullable=True, comment='20日')
    day21 = Column(String(20), nullable=True, comment='21日')
    day22 = Column(String(20), nullable=True, comment='22日')
    day23 = Column(String(20), nullable=True, comment='23日')
    day24 = Column(String(20), nullable=True, comment='24日')
    day25 = Column(String(20), nullable=True, comment='25日')
    day26 = Column(String(20), nullable=True, comment='26日')
    day27 = Column(String(20), nullable=True, comment='27日')
    day28 = Column(String(20), nullable=True, comment='28日')
    day29 = Column(String(20), nullable=True, comment='29日')
    day30 = Column(String(20), nullable=True, comment='30日')
    day31 = Column(String(20), nullable=True, comment='31日')
    del_flag = Column(CHAR(1), nullable=True, comment='删除标志')
    create_by = Column(String(64), nullable=True, comment='创建者')
    create_time = Column(DateTime, nullable=True, comment='创建时间')
    update_by = Column(String(64), nullable=True, comment='更新者')
    update_time = Column(DateTime, nullable=True, comment='更新时间')
    remark = Column(String(500), nullable=True, comment='备注')



